{"text_format":"2","workbook":"xls","n_sheets":19,"sheets":["Welcome","Help","Effective Length","Friction Rate","Duct Sizing","G1","G2","G3","G4","G5","G6","G7","G8","G9","G10","G11","G12","G13","Notes"],"not_rendered":{"charts":0,"images":28,"macros":0,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Welcome","index":0,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[[20,8,20,9],[0,4,0,6]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,null,null,"Welcome to the electronic spreadsheet version for the ACCA"]
[null,null,null,"Manual D, 3rd Edition (D3) -- Residential Duct Systems, 2008"]
[]
[null,"A thorough understanding of the D3 manual as well as a working knowledge of Microsoft"]
[null,"Excel are prerequisites for using this spreadsheet."]
[]
[null,"This spreadsheet uses revised versions of the printed D3 worksheets."]
[]
[null,"Use the printed D3 manual for guidance to enter information into the Effective Length,"]
[null,"Friction Rate and Duct Sizing tabs."]
[]
[null,"Microsoft Excel version 97 is the minimum requirement to use the spreadsheet but Microsoft"]
[null,"Excel version 2000 or greater is recommended to utilize the full features of the spreadsheet."]
[]
[null,"We strongly suggest that you print out and read the instructions on using this electronic spreadsheet "]
[null,"that are contained in the following Help tab."]
[]
[null,"This spreadsheet can be downloaded from the ACCA System Design website.  ",{"$nulls":6},"ACCA System Design"]
[null,"Please visit the website often to check for updates to the spreadsheet.  The most recent version"]
[null,"number is listed on Notes tab."]

{"sheet":"Help","index":1,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"ACCA Manual D, 3rd Edition"]
[]
[null," *** Refer to the Notes Tab to verify the latest revision ***"]
[]
[null,"Help Section "]
[null,null,"Refer to Manual D Residential Duct Systems, Third Edition Version 1.xx"]
[null,null,"Step 1:","Go to the Effective Length Tab and enter up to 4 supply runs to determine the longest equivilent run in the system."]
[null,null,null,"Enter the linear feet of trunk and runout ducts in the length sections for the supply ducts."]
[null,null,null,"Click on the Group Code and find the equivilent length for all fittings used in the selected supply runs."]
[null,null,null,"You can list multiple Group Code letters separated by a comma and enter the total effective length for all fittings. "]
[null,null,null,"The program will automatically select the \"Total Equivilent Feet\" to be used in the Friction Rate Tab."]
[null,null,null,"Repeat the steps above for the return ducts."]
[]
[null,null,"Step 2:","Go to the Friction Rate Tab and enter the \"External Static Pressure\" for the selected equipment."]
[null,null,null,"Enter the \"Heating CFM\" and \"Fan Speed / \"Cooling CFM\" and \"Fan Speed\"."]
[null,null,null,"Next enter \"Component Pressure Losses\" for all components and accesories external of the fan unit."]
[null,null,null,"The program will automatically calculate the \"Design Friction Rate\" value to be used for Duct Sizing."]
[]
[null,null,"Step 2:","Go to the Duct Sizing Tab and enter the heating and cooling BTUH for each supply run."]
[null,null,null,"There is a maximum of 20 supply runs per unit."]
[null,null,null,"For larger rooms divide the BTUH by the number of runs required for proper distribution of airflow."]
[null,null,null,"The program will automatically select the duct size for round metal ductwork."]
[null,null,null,"For rectangular metal ductwork enter the height and the program will automatically select the duct size."]
[null,null,null,"If Flex Duct is used refer to the Equivilent Flex column to select the correct duct size."]
[null,null,null,"Under the supply trunk, return run and return trunk sections, select the associated supply runs and the"]
[null,null,null,"CFM and duct sizes will automatically calculate."]
[null,null,null,"The program will automatically select the duct size for round metal ductwork."]
[null,null,null,"For rectangular metal ductwork enter the height and the program will automatically select the duct size."]
[null,null,null,"If Flex Duct is used refer to the Equivilent Flex column to select the correct duct size."]

{"sheet":"Effective Length","index":2,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":false,"merged":[[3,4,7,4],[3,6,7,6],[3,8,7,8],[26,8,26,9],[24,2,24,9],[46,2,46,9],[27,8,31,8],[26,1,27,1],[26,2,26,3],[26,4,26,5],[26,6,26,7],[32,1,33,1],[27,2,31,2],[27,4,31,4],[27,6,31,6],[0,1,0,9],[1,2,1,9],[25,2,25,9],[8,1,9,1],[2,1,3,1],[2,2,2,3],[2,4,2,5],[2,6,2,7],[2,8,2,9],[3,2,7,2]],"flags":["formulas_cached_only"]}
[null,"Effective Length Worksheet"]
[null,"Element","Supply Run ID Number"]
[null,"Straight Run",1,null,4,null,8,null,11]
[null,null,null,"Length",null,"Length",null,"Length",null,"Length"]
[null,"Trunk Length",null,3,null,3,null,3,null,3]
[null,"Trunk Length",null,20,null,25,null,40,null,43]
[null,"Trunk Length",{"$nulls":5},7,null,12]
[null,"Runout Length",{"$nulls":5},10]
[null,"Fittings","Group","Effective","Group","Effective","Group","Effective","Group","Effective"]
[null,null,"Letters","Length","Letters","Length","Letters","Length","Letters","Length"]
[null,"Group 1 ◄","1N",15,"1N",15,"1N",15,"1N",15]
[null,"Group 2 ◄","2P-3",65,"2P-4",70,"2P-5",75,"2P-5",75]
[null,"Group 3 ◄"]
[null,"Group 4 ◄","4K",30,"4K",30,"4K",30,"4K",30]
[null,"Group 8 ◄"]
[null,"Group 9 ◄","9P ",70,"9P",70,"9P",70,"9P",70]
[null,"Group 11 ◄"]
[null,"Group 12 ◄"]
[null,"Other",{"$nulls":4},"9O ",15]
[null,"Other"]
[null,"Other"]
[null,"Other"]
[null,"Other"]
[null,"Total Length",null,203,null,213,null,265,null,248]
[null,"Design TEL",265]
[null,"Element","Return Run ID Number"]
[null,"Straight Run",1,null,2,null,3,null,4]
[null,null,null,"Length",null,"Length",null,"Length",null,"Length"]
[null,"Trunk Length",null,4,null,5,null,5,null,5]
[null,"Trunk Length",null,null,null,5,null,5,null,10]
[null,"Trunk Length"]
[null,"Runout Length"]
[null,"Fittings","Group","Effective","Group","Effective","Group","Effective","Group","Effective"]
[null,null,"Letters","Length","Letters","Length","Letters","Length","Letters","Length"]
[null,"Group 5 ◄","5A",40,"5A",40,"5A",40,"5A",40]
[null,"Group 6 ◄","6F",25,"6F",25,"6F",25,"6F",25]
[null,"Group 7 ◄"]
[null,"Group 8 ◄"]
[null,"Group 10 ◄","10G",75,"10G",75,"10G",75,"10G",75]
[null,"Group 11 ◄"]
[null,"Group 12 ◄"]
[null,"Other"]
[null,"Other"]
[null,"Other"]
[null,"Other"]
[null,"Total Length",null,144,null,150,null,150,null,155]
[null,"Design TEL",155]

{"sheet":"Friction Rate","index":3,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[8,2,8,4],[9,2,9,4],[3,2,4,4],[5,2,5,4],[1,1,1,6],[15,2,15,4],[7,5,7,6],[8,5,8,6],[9,5,9,6],[20,1,20,4],[21,1,21,4],[22,1,22,4],[19,2,19,4],[0,1,0,6],[2,2,2,4],[16,2,16,4],[10,2,10,4],[7,2,7,4],[6,1,6,6],[18,2,18,4],[11,2,11,4],[12,2,12,4],[13,2,13,4],[14,2,14,4],[17,2,17,4],[18,5,18,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,5,17,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,5,13,6]],"flags":["formulas_cached_only"]}
[null,"Friction Rate Worksheet"]
[null,"Step 1) Manufacturer's Blower Data"]
[null,null,"External static pressure (ESP)",null,null,0.5,"IWC"]
[null,null,"CFM from manufacturers tables",null,null,"Heating","Cooling"]
[{"$nulls":5},1100,1040]
[null,null,"Fan Speed",null,null,"Med-Hi","Med"]
[null,"Step 2) Component Pressure Losses (CPL)"]
[null,null,"Direct expansion refrigerant coil"]
[null,null,"Electric resistance heating coil",null,null,0.02]
[null,null,"Hot water coil"]
[null,null,"heat exchanger"]
[null,null,"Low efficiency filter"]
[null,null,"High or mid-efficiency filter"]
[null,null,"Electronic filter"]
[null,null,"Humidfier",null,null,0.03]
[null,null,"Supply outlet",null,null,0.055]
[null,null,"Return grille",null,null,0.01]
[null,null,"Balancing damper ◄",null,null,0.03]
[null,null,"UV lights or other device"]
[null,null,"Total component losses (CPL)",null,null,0.14500000000000002,"IWC"]
[null,"Step 3) Available Static Pressure (ASP)",null,null,null,0.355,"IWC"]
[null,"Step 4) Total Effective Length (TEL)",null,null,null,420,"Feet"]
[null,"Step 5) Friction Rate Design Value (FR)",null,null,null,0.08452380952380953,"IWC/100"]
[null,"Notes:"]
[null,"Zero Component Pressure Losses will result in error."]
[null,"If the calculated friction rate is below .02 the fan may not deliver the required CFM"]
[null,"   * Increase the blower speed"]
[null,"   * Increase the blower size"]
[null,"   * Decrease the Total Effective Length (TEL)"]
[null,"If the calculated friction rate is above .18 the fan may not deliver too much CFM"]
[null,"   * Decrease the blower speed"]
[null,"   * Decrease the blower size"]
[null,"   * Increase the Total Effective Length (TEL)"]

{"sheet":"Duct Sizing","index":4,"n_rows":53,"n_cols":131,"rows_kept":53,"cut":false,"hidden":false,"merged":[[22,12,22,15],[23,16,23,18],[22,2,22,7],[19,19,19,21],[20,19,20,21],[19,12,19,15],[20,12,20,15],[19,2,19,7],[20,2,20,7],[21,2,21,7],[18,19,18,21],[36,2,36,21],[47,1,47,25],[21,19,21,21],[22,19,22,21],[23,19,23,21],[25,2,25,21],[21,16,21,18],[22,16,22,18],[21,12,21,15],[12,19,12,21],[13,19,13,21],[14,19,14,21],[15,19,15,21],[16,19,16,21],[17,19,17,21],[10,16,10,18],[11,16,11,18],[12,16,12,18],[9,19,9,21],[10,19,10,21],[2,19,2,21],[3,19,3,21],[4,19,4,21],[5,19,5,21],[11,19,11,21],[20,16,20,18],[13,16,13,18],[14,16,14,18],[15,16,15,18],[16,16,16,18],[6,19,6,21],[7,19,7,21],[8,19,8,21],[17,16,17,18],[9,16,9,18],[17,8,17,11],[18,8,18,11],[19,8,19,11],[20,8,20,11],[5,16,5,18],[6,16,6,18],[7,16,7,18],[8,16,8,18],[18,16,18,18],[19,16,19,18],[5,2,5,7],[6,2,6,7],[7,2,7,7],[15,12,15,15],[15,2,15,7],[13,8,13,11],[14,8,14,11],[15,8,15,11],[5,8,5,11],[6,8,6,11],[0,1,0,28],[1,1,1,25],[3,2,3,7],[4,2,4,7],[3,8,3,11],[4,8,4,11],[3,16,3,18],[2,16,2,18],[4,16,4,18],[2,12,2,15],[2,8,2,11],[2,2,2,7],[25,24,26,24],[14,12,14,15],[9,12,9,15],[10,12,10,15],[11,12,11,15],[11,2,11,7],[12,2,12,7],[7,8,7,11],[7,12,7,15],[8,12,8,15],[12,12,12,15],[10,2,10,7],[8,8,8,11],[8,2,8,7],[9,2,9,7],[35,1,35,25],[25,22,26,22],[25,23,26,23],[3,12,3,15],[4,12,4,15],[5,12,5,15],[23,8,23,11],[9,8,9,11],[10,8,10,11],[6,12,6,15],[35,26,35,27],[47,26,47,27],[13,2,13,7],[14,2,14,7],[13,12,13,15],[16,12,16,15],[16,2,16,7],[16,8,16,11],[23,1,23,7],[17,2,17,7],[25,26,26,26],[25,27,26,27],[17,12,17,15],[18,12,18,15],[25,25,26,25],[23,12,23,15],[24,1,24,25],[21,8,21,11],[22,8,22,11],[18,2,18,7],[48,2,48,21],[1,35,1,36],[24,26,24,27],[2,29,2,32],[1,26,1,27],[1,33,1,34],[25,28,26,28],[11,8,11,11],[12,8,12,11],[23,23,23,28]],"flags":["formulas_cached_only"]}
[null,"Duct Sizing Worksheet 1",{"$nulls":41},"ST-1",null,null,"CFM","ST-2",null,null,"CFM","ST-3",null,null,"CFM","ST-4",null,null,"CFM","ST-5",null,null,"CFM","ST-6",null,null,"CFM","ST-7",null,null,"CFM","ST-8",null,null,"CFM","RR-1",null,null,"CFM","RR-2",null,null,"CFM","RR-3",null,null,"CFM","RR-4",null,null,"CFM","RR-5",null,null,"CFM","RR-6",null,null,"CFM","RR-7",null,null,"CFM","RR-8",null,null,"CFM","RR-9",null,null,"CFM","RR-10",null,null,"CFM","RT-1",null,null,"CFM","RT-2",null,null,"CFM","RT-3",null,null,"CFM","RT-4",null,null,"CFM"]
[null,"Supply-side Runouts",{"$nulls":24},"Equivilent Rect. Duct",null,"Equivilent",{"$nulls":4},"Hank's Method",null,"Rounded",null,null,"HTG",null,"CLG",null,null,true,258.8235294117647,199.616122840691,258.8235294117647,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,258.8235294117647,199.616122840691,258.8235294117647,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,258.8235294117647,199.616122840691,258.8235294117647,false,0,0,0,false,0,0,0,false,0,0,0]
[null,"ID","Room ID",{"$nulls":5},"H-Btuh",null,null,null,"C-Btuh",null,null,null,"Htg Cfm",null,null,"Clg Cfm",null,null,"Dsn Cfm","Round Size","Velocity","Final Size","Height","Width","Flex","Ductulator",null,null,null,"Metal","Flex","Metal","Flex",null,"%","H-Cfm","%","C-Cfm",null,false,0,0,0,true,66.69683257918552,59.88483685220729,66.69683257918552,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,66.69683257918552,59.88483685220729,66.69683257918552,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,66.69683257918552,59.88483685220729,66.69683257918552,false,0,0,0,false,0,0,0,false,0,0,0]
[null,"SR-1",1,{"$nulls":5},8320,null,null,null,5600,null,null,null,258.8235294117647,null,null,199.616122840691,null,null,258.8235294117647,9,586.1537821073227,9,8,8,10,8.57,9,1,4,8.320863142521016,9.316888810517442,9,10,null,0.23529411764705882,258.8235294117647,0.19193857965451055,199.616122840691,null,false,0,0,0,true,19.90950226244344,19.961612284069098,19.961612284069098,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,19.90950226244344,19.961612284069098,19.961612284069098,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,19.90950226244344,19.961612284069098,19.961612284069098,false,0,0,0,false,0,0,0,false,0,0,0]
[null,"SR-2",2,{"$nulls":5},2144,null,null,null,1680,null,null,null,66.69683257918552,null,null,59.88483685220729,null,null,66.69683257918552,6,339.8564717410727,6,8,4,6,5.12,6,2,4,4.837366145991591,5.416409541415686,5,6,null,0.06063348416289593,66.69683257918552,0.05758157389635317,59.88483685220729,null,true,79.63800904977376,90.82533589251439,90.82533589251439,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,79.63800904977376,90.82533589251439,90.82533589251439,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,79.63800904977376,90.82533589251439,90.82533589251439,false,0,0,0,false,0,0,0]
[null,"SR-3",3,{"$nulls":5},640,null,null,null,560,null,null,null,19.90950226244344,null,null,19.961612284069098,null,null,19.961612284069098,4,228.8592491167158,4,8,2,4,3.24,4,3,4,2.9856928174266435,3.3430868319625575,4,4,null,0.01809954751131222,19.90950226244344,0.019193857965451054,19.961612284069098,null,true,79.63800904977376,90.82533589251439,90.82533589251439,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,79.63800904977376,90.82533589251439,90.82533589251439,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,79.63800904977376,90.82533589251439,90.82533589251439,false,0,0,0,false,0,0,0]
[null,"SR-4",4,{"$nulls":5},2560,null,null,null,2548,null,null,null,79.63800904977376,null,null,90.82533589251439,null,null,90.82533589251439,6,462.8042593249141,6,8,4,7,5.76,6,4,5,5.473305405080866,6.128472132242351,6,7,null,0.07239819004524888,79.63800904977376,0.0873320537428023,90.82533589251439,null,false,0,0,0,true,39.81900452488688,44.91362763915547,44.91362763915547,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,39.81900452488688,44.91362763915547,44.91362763915547,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,39.81900452488688,44.91362763915547,44.91362763915547,false,0,0,0,false,0,0,0]
[null,"SR-5",5,{"$nulls":5},2560,null,null,null,2548,null,null,null,79.63800904977376,null,null,90.82533589251439,null,null,90.82533589251439,6,462.8042593249141,6,8,4,7,5.76,6,5,6,5.473305405080866,6.128472132242351,6,7,null,0.07239819004524888,79.63800904977376,0.0873320537428023,90.82533589251439,null,false,0,0,0,true,79.63800904977376,103.8003838771593,103.8003838771593,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,79.63800904977376,103.8003838771593,103.8003838771593,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,79.63800904977376,103.8003838771593,103.8003838771593,false,0,0,0,false,0,0,0]
[null,"SR-6",6,{"$nulls":5},1280,null,null,null,1260,null,null,null,39.81900452488688,null,null,44.91362763915547,null,null,44.91362763915547,5,329.5573187280707,5,8,2,5,4.41,5,6,7,4.129696452304915,4.624030224784588,5,5,null,0.03619909502262444,39.81900452488688,0.04318618042226487,44.91362763915547,null,false,0,0,0,true,77.6470588235294,99.8080614203455,99.8080614203455,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,77.6470588235294,99.8080614203455,99.8080614203455,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,77.6470588235294,99.8080614203455,99.8080614203455,false,0,0,0,false,0,0,0]
[null,"SR-7",7,{"$nulls":5},2560,null,null,null,2912,null,null,null,79.63800904977376,null,null,103.8003838771593,null,null,103.8003838771593,7,388.5936638063418,7,8,5,7,6.06,7,7,8,5.7735969227473865,6.464709206800562,6,7,null,0.07239819004524888,79.63800904977376,0.09980806142034548,103.8003838771593,null,false,0,0,0,true,77.6470588235294,99.8080614203455,99.8080614203455,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,77.6470588235294,99.8080614203455,99.8080614203455,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,77.6470588235294,99.8080614203455,99.8080614203455,false,0,0,0,false,0,0,0]
[null,"SR-8",8,{"$nulls":5},2496,null,null,null,2800,null,null,null,77.6470588235294,null,null,99.8080614203455,null,null,99.8080614203455,6,508.5761091482573,6,8,4,7,5.97,6,8,9,5.683725891689939,6.364080415134711,6,7,null,0.07058823529411765,77.6470588235294,0.09596928982725528,99.8080614203455,null,false,0,0,0,true,91.58371040723982,59.88483685220729,91.58371040723982,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,91.58371040723982,59.88483685220729,91.58371040723982,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,91.58371040723982,59.88483685220729,91.58371040723982,false,0,0,0,false,0,0,0]
[null,"SR-9",9,{"$nulls":5},2496,null,null,null,2800,null,null,null,77.6470588235294,null,null,99.8080614203455,null,null,99.8080614203455,6,508.5761091482573,6,8,4,7,5.97,6,9,10,5.683725891689939,6.364080415134711,6,7,null,0.07058823529411765,77.6470588235294,0.09596928982725528,99.8080614203455,null,false,0,0,0,true,90.58823529411765,58.88675623800384,90.58823529411765,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,90.58823529411765,58.88675623800384,90.58823529411765,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,90.58823529411765,58.88675623800384,90.58823529411765,false,0,0,0,false,0,0,0]
[null,"SR-10",10,{"$nulls":5},2944,null,null,null,1680,null,null,null,91.58371040723982,null,null,59.88483685220729,null,null,91.58371040723982,6,466.6685880623685,6,8,4,7,5.78,6,10,12,5.491540245762748,6.148889723566792,6,7,null,0.0832579185520362,91.58371040723982,0.05758157389635317,59.88483685220729,null,false,0,0,0,true,67.6923076923077,49.90403071017275,67.6923076923077,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,67.6923076923077,49.90403071017275,67.6923076923077,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,67.6923076923077,49.90403071017275,67.6923076923077,false,0,0,0,false,0,0,0]
[null,"SR-11",11,{"$nulls":5},2912,null,null,null,1652,null,null,null,90.58823529411765,null,null,58.88675623800384,null,null,90.58823529411765,6,461.5961034095167,6,8,4,7,5.75,6,12,14,5.467585671887627,6.1220677343722665,6,7,null,0.08235294117647059,90.58823529411765,0.05662188099808062,58.88675623800384,null,false,0,0,0,true,70.6787330316742,61.880998080614205,70.6787330316742,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,70.6787330316742,61.880998080614205,70.6787330316742,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,true,70.6787330316742,61.880998080614205,70.6787330316742,false,0,0,0,false,0,0,0]
[null,"SR-12",12,{"$nulls":5},2176,null,null,null,1400,null,null,null,67.6923076923077,null,null,49.90403071017275,null,null,67.6923076923077,6,344.9289563939245,6,8,4,6,5.15,6,14,16,4.866117650823549,5.448602664781161,5,6,null,0.06153846153846154,67.6923076923077,0.04798464491362764,49.90403071017275,null,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0]
[null,"SR-13",13,{"$nulls":5},2272,null,null,null,1736,null,null,null,70.6787330316742,null,null,61.880998080614205,null,null,70.6787330316742,6,360.14641035247996,6,8,4,6,5.23,6,16,18,4.950879764319195,5.543510990186466,5,6,null,0.06425339366515836,70.6787330316742,0.05950095969289827,61.880998080614205,null,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0]
[null,"SR-14",{"$nulls":14},0,null,null,0,null,null,0,"","","",null,"","",0,{"$error":"#N/A"},18,20,0,0,{"$error":"#N/A"},{"$error":"#N/A"},null,0,0,0,0,null,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0]
[null,"SR-15",{"$nulls":14},0,null,null,0,null,null,0,"","","",null,"","",0,{"$error":"#N/A"},20,22,0,0,{"$error":"#N/A"},{"$error":"#N/A"},null,0,0,0,0,null,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0]
[null,"SR-16",{"$nulls":14},0,null,null,0,null,null,0,"","","",null,"","",0,{"$error":"#N/A"},null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"},null,0,0,0,0,null,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0]
[null,"SR-17",{"$nulls":14},0,null,null,0,null,null,0,"","","",null,"","",0,{"$error":"#N/A"},null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"},null,0,0,0,0,null,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0]
[null,"SR-18",{"$nulls":14},0,null,null,0,null,null,0,"","","",null,"","",0,{"$error":"#N/A"},null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"},null,0,0,0,0,null,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0,false,0,0,0]
[null,"SR-19",{"$nulls":14},0,null,null,0,null,null,0,"","","",null,"","",0,{"$error":"#N/A"},null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"},null,0,0,0,0,null,null,418.0995475113122,381.26679462571974,418.0995475113122,null,681.9004524886877,658.7332053742801,681.9004524886877,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,345.42986425339365,279.46257197696735,345.42986425339365,null,515.6561085972851,475.0863723608445,515.6561085972851,null,159.2760180995475,181.65067178502878,181.65067178502878,null,79.63800904977376,103.8003838771593,103.8003838771593,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,345.42986425339365,279.46257197696735,345.42986425339365,null,754.5701357466064,760.5374280230326,760.5374280230326,null,0,0,0,null,0,0,0]
[null,"SR-20",{"$nulls":14},0,null,null,0,null,null,0,"","","",null,"","",0,{"$error":"#N/A"},null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"},null,0,0,0,0]
[{"$nulls":8},35360,null,null,null,29176,null,null,null,1100,null,null,1040,null,null,1196.005766842393,{"$nulls":10},15.348296715442748,17.185521679579647,16,18,null,1,1100,1,1040]
[null,"Supply-side Trunks",{"$nulls":24},"Equivilent Rect. Duct",null,"Equivilent",{"$nulls":4},0,0]
[null,"ID","Associated Supply Runs",{"$nulls":19},"Dsn Cfm","Round Size","Velocity","Final Size","Height","Width","Flex"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,"ST-1",{"$nulls":20},418.0995475113122,12,532.6108885494423,12,8,14,12,10.28,12,null,null,10.080422985886768,11.287071847456966,12,12]
[null,"ST-2",{"$nulls":20},681.9004524886877,14,638.2013854047251,14,8,19,14,12.39,14,null,null,12.259006305166535,13.726436394441684,14,14]
[null,"ST-3",{"$nulls":20},0,"","","",null,"","",0,{"$error":"#N/A"},null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"ST-4",{"$nulls":20},0,"","","",null,"","",0,{"$error":"#N/A"},null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"ST-5",{"$nulls":20},0,"","","",null,"","",0,{"$error":"#N/A"},null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"ST-6",{"$nulls":20},0,"","","",null,"","",0,{"$error":"#N/A"},null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"ST-7",{"$nulls":20},0,"","","",null,"","",0,{"$error":"#N/A"},null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"ST-8",{"$nulls":20},0,"","","",null,"","",0,{"$error":"#N/A"},null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Return-side Runouts",{"$nulls":24},"Equivilent Rect. Duct",null,"Equivilent",{"$nulls":4},0,0]
[null,"ID","Associated Supply Runs",{"$nulls":19},"Dsn Cfm","Round Size","Velocity","Final Size","Height","Width","Flex"]
[null,"RR-1",{"$nulls":20},345.42986425339365,10,633.6547828342507,10,8,10,12,9.56,10,null,null,9.3392248110073,10.457150616494594,10,12]
[null,"RR-2",{"$nulls":20},515.6561085972851,12,656.8867625443122,12,8,14,14,11.14,12,null,null,10.962533757348778,12.274773223564601,12,14]
[null,"RR-3",{"$nulls":20},181.65067178502878,8,520.6547917405284,8,8,6,9,7.49,8,null,null,7.2220697800802425,8.086567459445007,8,9]
[null,"RR-4",{"$nulls":20},103.8003838771593,7,388.5936638063418,7,8,5,7,6.06,7,null,null,5.7735969227473865,6.464709206800562,6,7]
[null,"RR-5",{"$nulls":20},0,"","","",null,"","",0,{"$error":"#N/A"},null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"RR-6",{"$nulls":20},0,"","","",null,"","",0,{"$error":"#N/A"},null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"RR-7",{"$nulls":20},0,"","","",null,"","",0,{"$error":"#N/A"},null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"RR-8",{"$nulls":20},0,"","","",null,"","",0,{"$error":"#N/A"},null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"RR-9",{"$nulls":20},0,"","","",null,"","",0,{"$error":"#N/A"},null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"RR-10",{"$nulls":20},0,"","","",null,"","",0,{"$error":"#N/A"},null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Return-side Trunks",{"$nulls":24},"Equivilent Rect. Duct",null,"Equivilent"]
[null,"ID","Associated Supply Runs",{"$nulls":19},"Dsn Cfm","Round Size","Velocity","Final Size","Height","Width","Flex"]
[null,"RT-1",{"$nulls":20},345.42986425339365,10,633.6547828342507,10,8,10,12,9.56,10,null,null,9.3392248110073,10.457150616494594,10,12]
[null,"RT-2",{"$nulls":20},760.5374280230326,14,711.7989707221933,14,8,19,16,12.91,14,null,null,12.806047655190667,14.33895980044329,14,16]
[null,"RT-3",{"$nulls":20},0,"","","",null,"","",0,{"$error":"#N/A"},null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"RT-4",{"$nulls":20},0,"","","",null,"","",0,{"$error":"#N/A"},null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"G1","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"G2","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"G3","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"G4","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"G5","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"G6","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"G7","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"G8","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"G9","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"G10","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"G11","index":15,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"G12","index":16,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"G13","index":17,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Notes","index":18,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["Release Notes:"]
[]
["Version MD3 1.00 01SEP09","Initial Release"]
[]
["Version MD3 1.01 03NOV09","Added heating and cooling cfm's and fan speed on Friction Rate tab"]
[null,"Increased supply runs to 20 on Duct Sizing tab"]
[null,"Increased supply trunks to 8 on Duct Sizing tab"]
[null,"Decreased return runs to 10 on Duct Sizing tab"]
[null,"Eliminated second Duct Sizing tab"]
[null,"Show heating and cooling cfm's on Duct Sizing tab"]